home *** CD-ROM | disk | FTP | other *** search
/ Programming Languages Suite / ProgramD2.iso / Visual Database / Visual dBase v5.5 / SAMPLES1.PAK / CUSTORD.QBE < prev    next >
Text File  |  1995-07-18  |  386b  |  17 lines

  1. * dBASE Windows .QBE file 9
  2. CLOSE DATABASES
  3. SET EXACT ON
  4. SELECT 1
  5. USE CUSTOMER.DBF ORDER TAG NAME
  6. SELECT 2
  7. USE ORDERS.DBF ORDER TAG CUSTOMER_N
  8. SELECT 3
  9. USE LINEITEM.DBF ORDER TAG ORDER_NO
  10. SELECT 1
  11. SET RELATION TO CUSTOMER_N INTO ORDERS CONSTRAIN INTEGRITY
  12. SELECT 2
  13. SET RELATION TO ORDER_NO INTO LINEITEM CONSTRAIN INTEGRITY
  14. *SET SKIP TO ORDERS, LINEITEM
  15. SELECT 1
  16. GO TOP
  17.